package com.heima.mapper;

import com.heima.poji.Dept;
import com.heima.poji.Result;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeptMapper {


   @Select("select * from dept;")
   public List<Dept> list();

   @Delete("delete from dept where id=#{id}")
   void delectById(Integer id);


   @Insert("insert into dept (name, create_time, update_time) values (#{name},#{createTime},#{updateTime})")

   void add(Dept dept);


   @Update("update dept set name=#{name} ,update_time=#{updateTime} where id =#{id} ")
   void update(Dept dept);

   @Select("select * from dept where id=#{id}")
   Dept selectByid(Integer id);
}
